/* Given:
     * A PriceSheetVersion key
     * A Product key
  
   Obtain the price break-related data for the Product.

   Results will vary by currency, uom, and minquantity.
*/
CREATE PROCEDURE [dbo].[asi_PrcQueryPriceBreakForVersion]
    @priceSheetVersionKey uniqueidentifier,
    @productKey uniqueidentifier
    AS
BEGIN
    SELECT sheet.Name, ver.PriceSheetVersionKey, ver.Version, ver.Adjustment, ver.IsAdjustmentPercent, verdet.IsVersionOwner, det.CurrencyCode, pbreak.UomKey, pbreak.UnitRate, pbreak.PriceBasisCode, pbreak.IsPercent, pbreak.MinQuantity
    FROM PriceSheet sheet
    INNER JOIN PriceSheetVersion ver ON ver.PriceSheetKey=sheet.PriceSheetKey
    INNER JOIN PriceVersionDetail verdet ON verdet.PriceSheetVersionKey=ver.PriceSheetVersionKey
    INNER JOIN PriceDetail det ON det.PriceDetailKey=verdet.PriceDetailKey
    INNER JOIN PriceBreak pbreak ON pbreak.PriceDetailKey=det.PriceDetailKey
    WHERE ver.PriceSheetVersionKey=@priceSheetVersionKey
    AND det.ProductKey=@productKey
    ORDER BY sheet.PriceSheetKey, Version ASC, det.CurrencyCode, pbreak.UomKey, MinQuantity ASC
END

GO